package com.woniu.springbootshiro.mapper;

import com.woniu.springbootshiro.pojo.Set;
import com.woniu.springbootshiro.pojo.SetLight;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface SetMapper extends tk.mybatis.mapper.common.Mapper<Set>{
@Select("select `check`,id,`name`,`type`,url,`status`,status01,xy,low,light,oper from lamp_info")
    List<Set> queryAllLamp();

@Delete("delete from lamp_info where zid=#{zid}")
    String deleteLamp();

    @Select("select `check`,id,`name`,`type`,url,`status`,status01,xy,low,light,oper from lamp_info where `status`!='正常'")
    List<Set> queryBad();
}
